{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Help","Sand Cone Density","Drive Tube Density","Nuclear Density"],"not_rendered":{"charts":0,"images":35,"macros":1,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,4,11]]}

{"sheet":"Sand Cone Density","index":1,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[22,1,22,10],[23,1,23,10],[0,0,0,10]]}
[]
["Project Number"]
["Project Name"]
["Client"]
["Test Date"]
["Test #"]
["Initial Weight of Jar & Sand"]
["Weight of Jar & Sand Retained"]
["Weight of Sand Used",{"$f":"B7-B8","v":0},{"$f":"C7-C8","v":0},0,0]
["Weight of Sand in Cone & Plate"]
["Weight of Sand Used in Hole",{"$f":"B9-B10","v":0},{"$f":"C9-C10","v":0},0,0]
["Density of Sand"]
["Volume of Hole",{"$f":"B11/B12","v":{"$error":"#DIV/0!"}},{"$f":"C11/C12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Wet Weight (Rock/Soil/Container)"]
["Weight of Container"]
["Wet Weight of Soil",{"$f":"B14-B15","v":0},{"$f":"C14-C15","v":0},0,0]
["Wet Density",{"$f":"B16/B13","v":{"$error":"#DIV/0!"}},{"$f":"C16/C13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Wet Weight of Moisture Sample"]
["Dry Weight of Moisture Sample"]
["Weight of Water",{"$f":"B18-B19","v":0},{"$f":"C18-C19","v":0},0,0]
["% Moisture Content",{"$f":"100*(B20/B19)","v":{"$error":"#DIV/0!"}},{"$f":"100*(C20/C19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Dry Density",{"$f":"B17*(1+B21/100)","v":{"$error":"#DIV/0!"}},{"$f":"C17*(1+C21/100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Moisture Content"]
["Compaction Test"]
["Weight of Soil & Mold"]
["Weight of Mold"]
["Weight of Soil ",{"$f":"B25-B26","v":0},{"$f":"C25-C26","v":0},0,0]
["Mold Volume Factor"]
["Wet Density",{"$f":"B28*B27","v":0},{"$f":"C28*C27","v":0},0,0]
["Wet Weight of Moisture Sample"]
["Dry Weight of Moisture Sample"]
["Weight of Water",{"$f":"B30-B31","v":0},{"$f":"C30-C31","v":0},0,0]
["% Moisture Content",{"$f":"100*(B32/B31)","v":{"$error":"#DIV/0!"}},{"$f":"100*(C32/C31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Dry Density",{"$f":"B29*(1+B33/100)","v":{"$error":"#DIV/0!"}},{"$f":"C29*(1+C33/100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["MDD. Maximum Dry Density",1.4,2.5,1.21,2.5]
["Optimum Moisture Content (%)",25,25,25,25]
["Percent Compaction",{"$f":"100*(B22/B35)","v":{"$error":"#DIV/0!"}},{"$f":"100*(C22/C35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Test Location"]
["Percent Moisture Required",25,25,25,25]
["Percent Compaction Required",95,95,95,95]
[]
[]
[]
[]
[]
["Did the Compaction Pass?"]
["Reason:"]

{"sheet":"Drive Tube Density","index":2,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,1,0,6],[21,1,21,12]]}
[]
["Project Number"]
["Project Name"]
["Client"]
["Test Date"]
["Test Number",1]
["Drive Cylinder ID"]
["Drive Cylinder Height (in)"]
["Drive Cylinder Diamter (in)"]
["Drive Cylinder Volume (cf)"]
["Wet Weight of Sample & Cylinder",3.65]
["Weight of Cylinder (lb)",0.75]
["Wet Weight of sample (A-B) (lb)",{"$f":"a-b","v":2.9},{"$f":"a-b","v":2.9},{"$f":"a-b","v":2.9},{"$f":"a-b","v":2.9}]
["Cylinder Volume Factor",0.72]
["Wet density (pcf) (CxD)"]
["Tare Weight (t)"]
["Wet weight of Moitsture Sample(-t)",300]
["Dry Weight of Moisture Sample (-t)",265]
["Weight of water (F-G) (grams)"]
["% Moisture Content (100xH/(g-t))",{"$f":"100*h/(g-t)","v":0},{"$f":"100*h/(g-t)","v":0},{"$f":"100*h/(g-t)","v":0},{"$f":"100*h/(g-t)","v":0}]
["Dry Density (pcf)(E/(1+I/100))",{"$f":"e/(1+i/100)","v":0},{"$f":"e/(1+i/100)","v":0},{"$f":"e/(1+i/100)","v":0},{"$f":"e/(1+i/100)","v":0}]
["Moisture Content Compaction Test"]
["Compaction Test"]
["Compaction Test Method A,B,C,D"]
["Weight of Soil and Mold",12.54]
["Weight of Mold",9.75]
["Weight of Soil (Q-R)",{"$f":"q-rr","v":2.7899999999999991},{"$f":"q-rr","v":2.7899999999999991},{"$f":"q-rr","v":2.7899999999999991},{"$f":"q-rr","v":2.7899999999999991}]
["Mold Volume Factor",0.72]
["Wet Desnsity (pcf) (TxS)",{"$f":"B28*s","v":2.0087999999999995},{"$f":"C28*s","v":0},{"$f":"D28*s","v":0},{"$f":"E28*s","v":0}]
["Tare Weight (t)"]
["Wet Weight of Moisture Sample (+t)",300]
["Dry Weight of Moisture Sample (+t)",263]
["Weight of Water(V-W) (grams)",{"$f":"v-w","v":37},{"$f":"v-w","v":37},{"$f":"v-w","v":37},{"$f":"v-w","v":37}]
["% Moisture Content (100xX/(W-t))",{"$f":"100*(x/(w-t))","v":14.068441064638785},{"$f":"100*(x/(w-t))","v":14.068441064638785},{"$f":"100*(x/(w-t))","v":14.068441064638785},{"$f":"100*(x/(w-t))","v":14.068441064638785}]
["Dry Density (pcf) (U/1+Y(100))",{"$f":"u/(1+(y/100))","v":1.7610479999999995},{"$f":"C29/(1+(C34/100))","v":0},{"$f":"D34/(1+(D34/100))","v":12.333333333333336},{"$f":"E29/(1+(E34/100))","v":0}]
["Mdd  Maximum Dry Density (pcf)",1.9]
["Optimum Moisture Content (%)",13.78]
["Percent Compaction (100xP/Mdd))",{"$f":"(100*p)/B36","v":0},{"$f":"(100*C21)/C36","v":{"$error":"#DIV/0!"}},{"$f":"(100*D21)/D36","v":{"$error":"#DIV/0!"}},{"$f":"(100*E21)/E36","v":{"$error":"#DIV/0!"}}]
["Percent Moisture Required",13.78]
["Percent Compaction Required",95]
[]
[]
[]
[]
[]
["Did the Compaction Pass?","fail"]
["Reasons:","Both requirements are not met"]

{"sheet":"Nuclear Density","index":3,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[]
["Project Number"]
["Project Name"]
["Client"]
["Test Date"]
["Test #"]
["Test Location"]
["Application"]
["Depth/Elevation"]
["Density Standard Counts"]
["Moisture Standard Counts"]
["Probe Depth"]
["A. Wet Density (PCF ) (Gauge)"]
["B. % Moisture Content (Gauge)"]
["Moisture Content (Inscert checks)"]
["C. Wet Weight of Moisture Sample"]
["D. Dry Weight of Moisture Sample"]
["E. Weight of Water (C-D)"]
["F. % Moisture content (100xE/D)"]
["G. Moisture Correction (B-F) or (ave G)"]
["H. Correct Moisture (B-G) or (B-Ave G)"]
["P. Dry Density (PCF)"]
["Material Description"]
["Compaction Test"]
["Compaction Test Method A,B,C,D"]
["Pcoture curve number "]
["Check Plug Test #"]
["Mdd. Maximum Dry Density (PCF)"]
["Optimum Moistre Content (%)"]
["Percent Compaction (100XP/MDD)"]
["Percent Moisture Required"]
["Percent Compaction Required"]